CentOS 7
Sponsored Link

Oracle Database 12c Release 2 : Create Database
2015/07/05
 
Create Database.
[1] Login with the oracle admin user and input a command [dbca] like follows.
[oracle@dlp ~]$ dbca

[2] Select [Create Database] and go next.
[3] On this example, select [Advanced Mode] and go next.
[4] This example selects [General Purpose ***] and go next.
[5] Set Grobal Database name and SID like follows. Set any name you like.
[6] This example goes next with keeping default.
[7] This example goes next with keeping default.
[8] This example goes next with keeping default.
[9] This example goes next with keeping default.
[10] Configure memory settings. After setting, go to next tab.
[11] Specify max processes.
[12] Set Character setting.
[13] Select a connection mode. If your server does not have many clients, Select Dedicated server mode. If your server has many clients, Select Shared server mode.
[14] Set Oracle Enterprise Manager's port. This example goes next with keeping default.
[15] Set Oracle users' password. Please set a password for a user for security.
[16] This example goes next with keeping default.
[17] Confirm selections. If it's OKI, Click [Finish] button.
[18] Database creation starts.
[19] After finishing creatrion of Database, Add Database SID to the environment variables and test to connect to the database.
[oracle@dlp ~]$
vi /etc/oratab
# change like follows

db01:/u01/app/oracle/product/12.2.0/dbhome_1:
Y
[oracle@dlp ~]$
vi ~/.bash_profile
# add to the end

export ORACLE_SID=db01
[oracle@dlp ~]$
source ~/.bash_profile

[oracle@dlp ~]$
sqlplus /nolog 


SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 12 19:23:54 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> select instance_name, host_name, version, startup_time from v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T
----------------- ---------
db01
dlp.srv.world
12.2.0.1.0        13-OCT-17


SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[20] If you'd like to use Enterprise Manager from another Hosts and also if Firewalld is running, allow service port.
[root@dlp ~]#
firewall-cmd --add-port=5500/tcp --permanent

success
[root@dlp ~]#
firewall-cmd --reload

success
 
Tweet